package org.example.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.example.entity.TempContractInfo;

import java.util.List;

/**
 * ============================================================<br>
 * <p> ProjectName ：dianguanjiaexportdata </p>
 * <p> @author dongjianzhao </p>
 * <p> @date 2023/3/18 </p>
 * <p> @version ：1.0 </p>
 * ============================================================<br>
 * <p>
 * TempContractInfo
 * </p>
 * ============================================================<br>
 */
@Mapper
public interface TempContractInfoMapper extends BaseMapper<TempContractInfo> {
    @Select("select * from temp_contract_info;")
    List<TempContractInfo> selectAll();
    @Select("SELECT\n" + "\t* \n" + "FROM\n" + "\ttemp_contract_info a\n" + "WHERE\n"
            + "\tciId NOT IN ( SELECT ciId FROM temp_contract )")
    List<TempContractInfo> allList();
}
